<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Grouping data with new rows, filtering data and recalculating data: Derived elements</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { color:#000000; font-weight:normal; }
ul.whs2 { list-style:disc; }
ol.whs3 { list-style:decimal; }
p.whs4 { margin-left:80px; }
p.whs5 { margin-left:0px; }
p.whs6 { margin-left:40px; }
img_whs7 { border:none; width:16px; height:18px; border-style:none; }
p.whs8 { margin-left:0px; font-weight:bold; }
p.whs9 { margin-left:0px; font-weight:normal; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs5 {margin-left:1pt; }";
  strNSS += "p.whs8 {margin-left:1pt; }";
  strNSS += "p.whs9 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nGrouping data with new rows, filtering data, and recalculating data: Derived elements\nWorking with derived elements");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Grouping data with new rows, filtering data, and recalculating data: 
 Derived elements</h1>
<p class="whs1">You may want to look at 
 report or document data in a different way by grouping some report rows 
 into a single row and renaming the new group you have created. For example, 
 if your report displays profit data from 2005, 2006, 2007, and 2008 on 
 separate rows, you might want to group the 2005, 2006, and 2007 rows together 
 into a single row on the report, and name that new row Profits Through 
 2007. </p>
<p class="whs1">When you are finished analyzing 
 the report, you can save the report in your My Reports folder. You can 
 also save your new group of report rows as a separate object called a 
 derived element, to be used again on a different report. To use a derived 
 element on another report, the other report must contain the attribute 
 that the derived element was originally based on. For example, using the 
 example above, the derived element was made up of the elements 2005, 2006, 
 and 2007. These elements are part of the Year attribute. To use the Profits 
 Through 2007 derived element on another report, that report must contain 
 the Year attribute.</p>
<p class="whs1">For an introduction to 
 derived elements with examples and images, see the <span style="font-style: italic;"><I>MicroStrategy 
 OLAP Services Guide</I></span>.</p>
<h2>Prerequisites</h2>
<ul type="disc" class="whs2">
	
<li style=" color: #000000; " class=p><p class="whs1">You 
 must own the MicroStrategy OLAP Services product.</p></li>
	
<li style=" color: #000000; " class=p><p class="whs1">You 
 must have access to a report that is connected to an Intelligent Cube. 
 If you do not, then you must create one. To create an Intelligent Cube 
 report see 
<a href="Creating_a_report_that_accesses_an_Intelligent_Cube.htm">Creating 
 a report that accesses an Intelligent Cube</a>. </p></li>
</ul>
<h2>To add a new derived elements group </h2>
<ol type="1" class="whs3">
	
<li class=p><p>Open the Intelligent Cube report. </p></li>
	<ul type="disc" class="whs2">
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Create Report</B></span>. 
 </p></li>
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Choose Intelligent 
 Cube</B></span>. </p></li>
	</ul>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span><span>: 
 The Intelligent Cube must be created in Desktop. See the </span><span 
 style="font-style: italic;"><I>MicroStrategy OLAP Services Guide </I></span><span>for 
 more information. </span></p>
<ol type="1" class="whs3">
	<ul type="disc" class="whs2">
		
<li class=p><p>Locate and then click the Intelligent Cube you wish 
 to use in your report. Click <span style="font-weight: bold;"><B>OK</B></span><span>. 
 The report template opens. </span></p></li>
		
<li class=p><p>Drag and drop the objects in the Report Objects 
 pane to the report grid and then run the report.</p></li>
	</ul>
</ol>
<ol start="2" type="1" class="whs3">
	
<li class=p><p>Right click on the object heading for which you wish 
 to create a new derived elements group, and then click <span style="font-weight: bold;"><B>Derived 
 Elements</B></span>. The Derived Elements dialog box opens. </p></li>
</ol>
<ol start="3" type="1" class="whs3">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>New </B></span>and 
 then <span style="font-weight: bold;"><B>Group</B></span>. The <span style="font-weight: bold;"><B>New 
 Group</B></span> text box will appear. </p></li>
	
<li class=p><p>Rename the new group so that you can locate it later. 
 </p></li>
	
<li class=p>Add elements to the group under the <span style="font-weight: bold;"><B>Definition</B></span> 
 tab. Use the arrows to add or remove elements from the list.</li>
	<p><span style="margin-left: 40px; font-weight: bold;"><B>Note</B></span><span 
 style="margin-left: 40px;">: Use the </span><span style="margin-left: 40px; font-weight: bold;"><B>Search 
 for:</B></span><span style="margin-left: 40px;"> field to find a specific 
 element. </span></p>
	
<li class=p><p class="whs5">Click the <span style="font-weight: bold;"><B>Properties 
 </B></span>tab. <span style="margin-left: 0px;">Choose one of the options 
 in the </span><span style="margin-left: 0px; font-weight: bold;"><B>Element 
 behavior </B></span><span style="margin-left: 0px;">section:</span></p></li>
</ol>
<ol start="5" type="1" class="whs3">
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Consolidate 
 items into one element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Keep 
 individual items separate</p></li>
	</ul>
</ol>
<ol start="7" type="1" class="whs3">
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>Subtotal behavior </B></span>drop-down 
 list:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 this element when calculating subtotals </p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 the individual items that comprise this element when calculating subtotals 
 </p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not use this element when calculating subtotal</p></li>
	</ul>
</ol>
<ol start="8" type="1" class="whs3">
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>All Other behavior </B></span>section:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not include individual items in the All Other element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Include 
 individual items in the All Other element</p></li>
	</ul>
</ol>
<ol start="9" type="1" class="whs3">
	
<li class=p><p class="whs5">Click <span style="font-weight: bold;"><B>OK 
 </B></span>to apply the changes and close the dialog box. You should see your 
 new group in the report grid. </p></li>
</ol>
<p class="whs6"><span style="font-weight: bold;"><B>Note</B></span>: 
 Clicking the <img src="images/save_icon.gif" width="16px" height="18px" border="0" class="img_whs7"> icon 
 also allows you to save your new group for use in other reports. </p>
<h2>To add a new derived elements calculation </h2>
<ol type="1" class="whs3">
	
<li class=p><p>Open the Intelligent Cube report. </p></li>
	<ul type="disc" class="whs2">
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Create Report</B></span>. 
 </p></li>
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Choose Intelligent 
 Cube</B></span>. </p></li>
	</ul>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span><span>: 
 The Intelligent Cube must be created in Desktop. See the </span><span 
 style="font-style: italic;"><I>MicroStrategy OLAP Services Guide </I></span><span>for 
 more information. </span></p>
<ol type="1" class="whs3">
	<ul type="disc" class="whs2">
		
<li class=p><p>Locate and then click the Intelligent Cube you wish 
 to use in your report. Click <span style="font-weight: bold;"><B>OK</B></span><span>. 
 The report template opens. </span></p></li>
		
<li class=p><p>Drag and drop the objects in the Report Objects 
 pane to the report grid and then run the report.</p></li>
	</ul>
</ol>
<ol start="2" type="1" class="whs3">
	
<li class=p><p>Right click on the object heading for which you wish 
 to create a new derived elements calculation, and then click <span style="font-weight: bold;"><B>Derived 
 Elements</B></span>. The Derived Elements dialog box opens. </p></li>
</ol>
<ol start="3" type="1" class="whs3">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>New </B></span>and 
 then <span style="font-weight: bold;"><B>Calculation</B></span>. The <span style="font-weight: bold;"><B>New 
 Calculation</B></span> text box will appear. </p></li>
	
<li class=p><p>Rename the new calculation so that you can locate it 
 later. </p></li>
	
<li class=p><p>Click the <span style="font-weight: bold;"><B>Elements</B></span> 
 link under the <span style="font-weight: bold;"><B>Definition</B></span> tab 
 to add elements to the calculation. Use the arrows to add or remove elements 
 from the list.</p></li>
</ol>
<p class="whs6"><span style="font-weight: bold;"><B>Note</B></span>: 
 Use the <span style="font-weight: bold;"><B>Search for:</B></span> field to find 
 a specific element. </p>
<ol start="6" type="1" class="whs3">
	
<li class=p><p class="whs5">Choose a function from the 
 <span style="font-weight: bold;"><B>Function</B></span> drop-down list to use 
 it for all the components of the new calculation. The selected function 
 is displayed in the <span style="font-weight: bold;"><B>Preview</B></span> area.</p></li>
	
<li class=p><p class="whs5">Click the <span style="font-weight: bold;"><B>Groups</B></span> 
 link under the <span style="font-weight: bold;"><B>Definition</B></span> tab 
 to add groups to the calculation. Use the arrows to add or remove groups 
 from the list.</p></li>
	
<li class=p><p class="whs5">Click the <span style="font-weight: bold;"><B>Numbers</B></span> 
 link under the <span style="font-weight: bold;"><B>Definition</B></span> tab 
 to specify a number for the calculation. </p></li>
	
<li class=p><p class="whs5">Click the <span style="font-weight: bold;"><B>Properties 
 </B></span>tab. </p></li>
	
<li class=p><p class="whs5">Choose one of the options 
 in the <span style="font-weight: bold;"><B>Element behavior </B></span>section:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Consolidate 
 items into one element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Keep 
 individual items separate</p></li>
	</ul>
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>Subtotal behavior </B></span>drop-down 
 list:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 this element when calculating subtotals </p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 the individual items that comprise this element when calculating subtotal 
 </p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not use this element when calculating subtotal</p></li>
	</ul>
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>All Other behavior </B></span>section:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not include individual items in the All Other element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Include 
 individual items in the All Other element</p></li>
	</ul>
	
<li class=p><p class="whs5">Click <span style="font-weight: bold;"><B>OK 
 </B></span>to apply the changes and close the dialog box. You should see your 
 new calculation in the report grid. </p></li>
</ol>
<p class="whs6"><span style="font-weight: bold;"><B>Note</B></span>: 
 Clicking the <img src="images/save_icon.gif" width="16px" height="18px" border="0" class="img_whs7"> icon 
 also allows you to save your new calculation for use in other reports. 
 </p>
<h2>To add a new derived elements filter </h2>
<ol type="1" class="whs3">
	
<li class=p><p>Open the Intelligent Cube report. </p></li>
	<ul type="disc" class="whs2">
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Create Report</B></span>. 
 </p></li>
		
<li class=p><p>Click <span style="font-weight: bold;"><B>Choose Intelligent 
 Cube</B></span>. </p></li>
	</ul>
</ol>
<p class="whs4"><span style="font-weight: bold;"><B>Note</B></span><span>: 
 The Intelligent Cube must be created in Desktop. See the </span><span 
 style="font-style: italic;"><I>MicroStrategy OLAP Services Guide </I></span><span>for 
 more information. </span></p>
<ol type="1" class="whs3">
	<ul type="disc" class="whs2">
		
<li class=p><p>Locate and then click the Intelligent Cube you wish 
 to use in your report. Click <span style="font-weight: bold;"><B>OK</B></span><span>. 
 The report template opens. </span></p></li>
		
<li class=p><p>Drag and drop the objects in the Report Objects 
 pane to the report grid and then run the report.</p></li>
	</ul>
</ol>
<ol start="2" type="1" class="whs3">
	
<li class=p><p>Right click on the object heading for which you wish 
 to create a new derived elements filter, and then click <span style="font-weight: bold;"><B>Derived 
 Elements</B></span>. The Derived Elements dialog box opens. </p></li>
</ol>
<ol start="3" type="1" class="whs3">
	
<li class=p><p>Click <span style="font-weight: bold;"><B>New </B></span>and 
 then <span style="font-weight: bold;"><B>Filter</B></span>. The <span style="font-weight: bold;"><B>New 
 Filter</B></span> text box will appear. </p></li>
	
<li class=p><p>Rename the new filter so that you can locate it later. 
 </p></li>
	
<li class=p><p>Choose <span style="font-weight: bold;"><B>Qualify </B></span>to 
 filter on the attribute forms of the selected attribute. </p></li>
	
<li class=p><p>Select the form from which you like to qualify from 
 the drop-down list, then select an operator, and finally enter a value 
 in the text box.</p></li>
	
<li class=p><p>Choose <span style="font-weight: bold;"><B>Select </B></span>to 
 filter on the attribute elements of the selected attribute. </p></li>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>In List </B></span>or 
 <span style="font-weight: bold;"><B>Not In List</B></span> from the drop-down 
 list. </p></li>
	
<li class=p><p>Select the elements on which you would like to filter 
 and use the arrows to add or remove groups from the list.</p></li>
</ol>
<ol start="10" type="1" class="whs3">
	
<li class=p><p class="whs5">Click the <span style="font-weight: bold;"><B>Properties 
 </B></span>tab. </p></li>
	
<li class=p><p class="whs5">Choose one of the options 
 in the <span style="font-weight: bold;"><B>Element behavior </B></span>section:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Consolidate 
 items into one element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Keep 
 individual items separate</p></li>
	</ul>
</ol>
<ol start="12" type="1" class="whs3">
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>Subtotal behavior </B></span>drop-down 
 list:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 this element when calculating subtotals </p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Use 
 the individual items that comprise this element when calculating subtotals</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not use this element when calculating subtotals</p></li>
	</ul>
</ol>
<ol start="13" type="1" class="whs3">
	
<li class=p><p class="whs5">Choose one of the options 
 from the <span style="font-weight: bold;"><B>All Other behavior </B></span>section:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5">Do 
 not include individual items in the All Other element</p></li>
		
<li style="list-style: disc;" type=disc class=p><p class="whs5">Include 
 individual items in the All Other element</p></li>
	</ul>
</ol>
<ol start="14" type="1" class="whs3">
	
<li class=p><p class="whs5">Click <span style="font-weight: bold;"><B>OK 
 </B></span>to apply the changes and close the dialog box. You should see your 
 new filter in the report grid. </p></li>
</ol>
<p class="whs6"><span style="font-weight: bold;"><B>Note</B></span>: 
 Clicking the <img src="images/save_icon.gif" width="16px" height="18px" border="0" class="img_whs7"> icon 
 also allows you to save your new filter for use in other reports. </p>
<p class="whs8">&nbsp;</p>
<p class="whs8">Related topics</p>
<ul type="disc" class="whs2">
	
<li class=p><p class="whs9">
<a href="Creating_a_report_that_accesses_an_Intelligent_Cube.htm">Creating 
 a report that accesses an Intelligent Cube</a></p></li>
</ul>
<p>&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
